<?

$sql = "select * from tbl_product where id in (select product_id from tbl_product_special where status=0 order by sort,date_added desc)";

$result = @mysql_query($sql,$conn);

$total = countRecord("tbl_product_special","status=0");

?>

<table width="100%" border="0" cellspacing="0" cellpadding="0">

              <tr>

                <td colspan="3" class="style42"><table width="100%" border="0" cellspacing="0" cellpadding="0">

                    <tr>

                      <td width="2%"><img src="images/c_5.jpg" width="6" height="26" /></td>

                      <td width="73%" class="style43">S&#7843;n ph&#7849;m ti&ecirc;u bi&#7875;u</td>

                      <td width="25%" align="right"><img src="images/c_4.jpg" width="6" height="26" /></td>

                    </tr>

                </table></td>

              </tr>

              <tr>

                <td colspan="3" class="style44">

				<table border="0" cellpadding="0" cellspacing="0" width="100%">

                  <tbody>

                    <tr>

                      <td bgcolor="#ffffff">

					  <table border="0" cellpadding="0" cellspacing="0" width="100%">

                          <tbody>

                            <tr>

                              <td><script type="text/javascript" src="js/jquery.js"></script>

                                  <script type="text/javascript" src="js/featuredcontentglider.js"></script>

                                  <script type="text/javascript">

									featuredcontentglider.init({

									gliderid: "canadaprovinces", //ID of main glider container

									contentclass: "glidecontent", //Shared CSS class name of each glider content

									togglerid: "p-select", //ID of toggler container

									selected: 0, //Default selected content index (0=1st)

									persiststate: false, //Remember last content shown within browser session (true/false)?

									speed: 900, //Glide animation duration (in milliseconds)

									autorotate: true, //Auto rotate contents (true/false)?

									autorotateconfig: [4000, 8] //if auto rotate enabled, set [milliseconds_btw_rotations, cycles_before_stopping]

									})									

								</script>

                                  <div style="" id="canadaprovinces" class="glidecontentwrapper">

								 <? while($pro=mysql_fetch_assoc($result)){ ?>

                                    <div style="top: 0px; height: 230px; visibility: visible; z-index: 110;" class="glidecontent">

                                      <h3><strong><a  href="./?frame=product_detail&amp;id=<?=$pro['id']?>" class="link4"><?=$pro["name"]?></a></strong></h3>

                                      <table border="0" cellpadding="2" cellspacing="2" width="100%" class="style55">

                                        <tbody>

                                          <tr>

                                            <td align="center" height="160" width="180" valign="top"><? if($pro["image"]==''){?>

											<a  href="./?frame=product_detail&amp;id=<?=$pro['id']?>"><img src="images/spm.jpg" width="180" height="160" border="0"/></a>

											<? } else {?><a  href="./?frame=product_detail&amp;id=<?=$pro['id']?>"><img src="<?=$pro["image"]?>" width="180" height="160" border="0"/></a><? }?></td>

                                            <td height="160" valign="top"><?=$pro["detail_short"]?><br /></td>

                                          </tr>

                                        </tbody>

                                      </table>

                                      <table style="border-top: 1px solid rgb(247, 128, 101);" border="0" cellpadding="2" cellspacing="2" width="100%">

                                        <tbody>

                                          <tr>

                                            <td class="price"><?=$pro["price"]?>&nbsp;<?=$currencyUnit?></td>

                                            <td align="right" width="50%"><a  href="./?frame=product_detail&amp;id=<?=$pro['id']?>"><img src="images/details.gif" align="absmiddle" /></a> &nbsp; <a href="./?frame=cart&p=<? echo $pro['id']; ?>"><img src="images/buy.gif" align="absmiddle" /></a>&nbsp;</td>

                                          </tr>



                                        </tbody>

                                      </table>

                                    </div>

									<? }?>

                                </div>

								

								</td>

                            </tr>

                          </tbody>

                      </table></td>

                    </tr>

                    <tr>

                      <td bgcolor="#aaa9b1">

					  <table border="0" cellpadding="0" cellspacing="2" width="100%">

                          <tbody>

                            <tr>

                              <td align="right"><div lastselected="4pg" style="display: block;" id="p-select" class="glidecontenttoggler"> <a loadpage="3pg" href="#1" class="prev">Quay lại</a> <a pagenumber="0pg" href="#1" class="toc">1</a> <a pagenumber="1pg" href="#1" class="toc">2</a> <a pagenumber="2pg" href="#1" class="toc">3</a> <a pagenumber="3pg" href="#1" class="toc">4</a> <a pagenumber="4pg" href="#1" class="toc selected">5</a> <a pagenumber="5pg" href="#1" class="toc">6</a> <a pagenumber="6pg" href="#1" class="toc">7</a> <a pagenumber="7pg" href="#" class="toc">8</a> <a pagenumber="8pg" href="#1" class="toc">9</a> <a pagenumber="9pg" href="#1" class="toc">10</a> <a loadpage="5pg" href="#1" class="next">Xem ti&#7871;p</a></div></td>

                            </tr>

                          </tbody>

                      </table>

					  </td>

                    </tr>

                  </tbody>

                </table>

				</td>

              </tr>

              <tr>

                <td valign="bottom"><img src="images/c_7.jpg" width="6" height="6" /></td>

                <td width="99%" class="style45"></td>

                <td width="0%" align="right" valign="bottom"><img src="images/c_9.jpg" width="6" height="6" /></td>

              </tr>

            </table>